Backing Up a Microsoft SQL Server 2005 Database

You can create a full database backup of a Microsoft SQL Server 2005 database.

Performing a backup

1. Open Microsoft SQL Server 2005 Management Studio.
2. Connect to the SQL server used by Workflow.



3. Click the server name to expand the server tree.



4. Expand the Databases folder and right-click the database used by Workflow.

   

   Note: The SQL server and database used by Workflow is defined using the Workflow Server Configuration Manager.

5. Point to Tasks and select Back Up.
6. Next to Backup Type, select Full.



7. For Backup component, select Database.



8. Optional: In the Description text box, enter a description of the backup.



9. Specify when the backup will expire and can be overwritten:



• To configure the backup to expire after a specific number of days, click After and enter the number of days. Entering zero (0) configures the backup to never expire.
• To configure the backup to expire on a specific date, click On and enter a date.
10. Choose the type of backup destination by clicking Disk or Tape. To select more paths, click Add.



11. Optional: To view or select the advanced options, click Options in the Select a page Pane.



12. When you have finished configuring, click OK to start the backup process.